Model Table CUT OFF DATE

Attributes

AttributeDescription (where applicable)
Current Month FlagCurrent month flag, day in current month
Current Year FlagCurrent year flag, day in current yea
Cut Off DateCut Off Date
Cut Off Date StringDate as string, fixed format, not NLS dependent
Cut Off MonthMonth Name
Cut Off Month NoMonth Number
Cut Off Month ShortMonth short, 3 char, NLS dependent
Cut Off QuarterQuarter, not NLS dependent
Cut Off WeekdayWeek Day
Cut Off Weekday NoWeek Day Number
Cut Off YearCut off year
Cut Off Year MonthYear month
Last 12 Months FlagLast 12 months flag, day between curr month-1 and curr month-12
Last 24 Months FlagLast24 months flag, day between curr month-24 and curr month-1
Year (Week based)Year, NLS dependent
Cut Off Week NoWeek Number

Hierarchies

HierarchyLevel
CutOffMSHy
Cut Off Year
Cut Off Quarter
Cut Off Month
CutOffMFHy
Cut Off Year
Cut Off Quarter
Cut Off Month
Cut Off Date
CutOffWSHy
Cut Off Year
Cut Off Week No
CutOffWFHy
Cut Off Year
Cut Off Week No
Cut Off Date

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
CUT OFF DATEDIM_BI_TIME_TMDIM_BI_TIME_BIDIM_BI_TIMEOn Line